Optimal distributed execution of join queries
نویسندگان
چکیده
منابع مشابه
An Optimal Evaluation of GroupBy-Join Queries in Distributed Architectures
aPDBMS : Parallel Database Management Systems. Abstract: SQL queries involving join and group-by operations are fairly common in many decision support applications where the size of the input relations is usually very large, so the parallelization of these queries is highly recommended in order to obtain a desirable response time. Several parallel algorithms that treat this kind of queries have...
متن کاملAchieving High Freshness and Optimal Throughput in Resource-Limited Execution of Multi-Join Continuous Queries
Due to high data volumes and unpredictable arrival rates, continuous query systems processing expensive queries in real-time may fail to keep up with the input data streams resulting in buffer overflow and uncontrolled loss of data. In this work, we explore join direction adaptation (JDA) to tackle resource-limited processing of multi-join stream queries. While the existing JDA solutions alloca...
متن کاملAchieving High Freshness and Optimal Throughput in CPU-Limited Execution of Multi-join Continuous Queries
Due to high data volumes and unpredictable arrival rates, continuous query systems processing expensive queries in real-time may fail to keep up with the input data streams resulting in buffer overflow and uncontrolled data loss. We explore join direction adaptation (JDA) to tackle CPU-limited processing of multijoin stream queries. The existing JDA solutions allocate the scarce CPU resources t...
متن کاملOptimization of Multi-Way Join Queries for Parallel Execution
Most of the existing relational database query optimizers generate multi-way join plans only from those linear ones to reduce the optimization overhead. For multiprocessor computer systems, this strategy seems inadequate since it may reduce the search space too much to generate near-optimal plans. In this paper we present a framework for optimization of multiway join queries in multiprocessor c...
متن کاملOptimization of Parallel Execution for Multi-Join Queries
In this paper, we study the subject of exploiting inter-operator parallelism to optimize the execution of multi-join queries. Speciically, we focus on two major issues: (i) scheduling the execution sequence of multiple joins within a query, and (ii) determining the number of processors to be allocated for the execution of each join operation obtained in (i). For the rst issue, we propose and ev...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Computers & Mathematics with Applications
سال: 1994
ISSN: 0898-1221
DOI: 10.1016/0898-1221(94)90094-9